<?php

namespace Jhub1_Common\Entity;

use Doctrine\ORM\Mapping as ORM;
use Doctrine\Common\Annotations\AnnotationReader;
use Doctrine\Common\Annotations\AnnotationRegistry;

/**
 * @ORM\Entity
 * @ORM\Table(name="ofUserFlag")
 */
class OfUserFlag
{

    /**
     * @ORM\Id
     * @ORM\Column(type="string", name="username", length=64, unique=true, nullable=false);
     * @var string
     */
    private $username;

    /**
     * @ORM\Column(type="string", name="name", length=100, unique=true, nullable=false)
     * @var string
     */
    private $name;

    /**
     * @ORM\Column(type="string", name="startTime", columnDefinition="CHAR(15)")
     * @var string
     */
    private $startTime;

    /**
     * @ORM\Column(type="string", name="endTime", columnDefinition="CHAR(15)")
     * @var string
     */
    private $endTime;

    public function getName()
    {
        return $this->name;
    }

    public function setName($val)
    {
        $this->name = $val;
    }

    public function getUsername()
    {
        return $this->username;
    }

    public function setUsername($val)
    {
        $this->username = $val;
    }

    public function getStartTime()
    {
        return $this->startTime;
    }

    public function setStartTime($val)
    {
        $this->startTime = $val;
    }

    public function getEndTime()
    {
        return $this->endTime;
    }

    public function setEndTime($val)
    {
        $this->endTime = $val;
    }
}

/*
CREATE TABLE ofUserFlag
(
    username VARCHAR(64) NOT NULL,
    name VARCHAR(100) NOT NULL,
    startTime CHAR(15),
    endTime CHAR(15),
    PRIMARY KEY ( username, name )
);
CREATE INDEX ofUserFlag_eTime_idx ON ofUserFlag ( endTime );
CREATE INDEX ofUserFlag_sTime_idx ON ofUserFlag ( startTime );
*/